[dbo].[CertificationModule]

Property	Value
Created	10:31:15 AM Tuesday, March 02, 2010
Last Modified	1:20:14 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
CertificationModuleKey	uniqueidentifier	16
CertificationModuleName	nvarchar(50)	100
CertificationModuleCode	nvarchar(50)	100
CertificationModuleDesc	nvarchar(250)	500
NumberOfUnits	decimal(18,8)	9
RequiresGradeFlag	bit	1
RequiresApprovalFlag	bit	1
CertificationStaffOnlyFlag	bit	1
CertificationModuleLocation	nvarchar(50)	100
CertificationModuleDate	datetime	8
CertificationModuleStatusCode	nchar(2)	4
UpdatedOn	datetime	8
UpdatedByUserKey	uniqueidentifier	16
CreatedOn	datetime	8
CreatedByUserKey	uniqueidentifier	16
MarkedForDeleteOn	datetime	8

	Name	Columns	Unique
	PK_CertificationModule_CertificationModuleKey	CertificationModuleKey
	IX_CertificationModule_CertificationModuleStatusCode	CertificationModuleStatusCode
	IX_CertificationModule_CreatedByUserKey	CreatedByUserKey
	IX_CertificationModule_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_CertificationModule_CertificationModuleStatusRef	CertificationModuleStatusCode->[dbo].[CertificationModuleStatusRef].[CertificationModuleStatusCode]
FK_CertificationModule_UserMain_CreatedBy	CreatedByUserKey->[dbo].[UserMain].[UserKey]
FK_CertificationModule_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[CertificationModule]
(
[CertificationModuleKey] [uniqueidentifier] NOT NULL,
[CertificationModuleName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CertificationModuleCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CertificationModuleDesc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NumberOfUnits] [decimal] (18, 8) NULL,
[RequiresGradeFlag] [bit] NOT NULL,
[RequiresApprovalFlag] [bit] NOT NULL,
[CertificationStaffOnlyFlag] [bit] NOT NULL,
[CertificationModuleLocation] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CertificationModuleDate] [datetime] NULL,
[CertificationModuleStatusCode] [nchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationModule] ADD CONSTRAINT [PK_CertificationModule_CertificationModuleKey] PRIMARY KEY CLUSTERED ([CertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModule_CertificationModuleStatusCode] ON [dbo].[CertificationModule] ([CertificationModuleStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModule_CreatedByUserKey] ON [dbo].[CertificationModule] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModule_UpdatedByUserKey] ON [dbo].[CertificationModule] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationModule] ADD CONSTRAINT [FK_CertificationModule_CertificationModuleStatusRef] FOREIGN KEY ([CertificationModuleStatusCode]) REFERENCES [dbo].[CertificationModuleStatusRef] ([CertificationModuleStatusCode])
GO
ALTER TABLE [dbo].[CertificationModule] ADD CONSTRAINT [FK_CertificationModule_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CertificationModule] ADD CONSTRAINT [FK_CertificationModule_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO